"""
@file: customs.py
@author: yangsiting
@data: 2021/04/14
@desc:
"""
from .base import db

# 商品信息表
class Goods_info(db.Model):
    __tablename__ = "goods_info"
    goods_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    goods_name = db.Column(db.String(255))
    goods_link = db.Column(db.String(255))
    goods_img = db.Column(db.String(255))
    goods_price = db.Column(db.Float)
    goods_category = db.Column(db.Integer)




class Goods_detail(db.Model):
    __tablename__ = "goods_details"
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    goods_id = db.Column(db.ForeignKey('goods_info.goods_id'))
    goods_detail = db.Column(db.String(255))



